﻿CREATE PROCEDURE [sp_ssiscatalog].[show_docs]
/*This sproc outputs whatever string is passed to it using standard print functionality.
At the time of writing it consists of just a single line:
	PRINT	@docs;
although I envisage that in the future I may wish to augment whatever gets passed in some generic manner - 
having a dedicated sproc for outputting "stuff" enables me to do that.
Essentially I'm following the single responsibility principle http://en.wikipedia.org/wiki/Single_responsibility_principle
*/
		@docs				NVARCHAR(MAX)
,		@action				NVARCHAR(MAX)	=	NULL
,		@show_docs			BIT				=	1
AS
BEGIN
		IF (@show_docs = 1)
		BEGIN
				DECLARE	@stars NVARCHAR(MAX) = '****************************************************************';
				PRINT	@stars
				IF @action IS NOT NULL
						PRINT	'For @action=' + @action;
				PRINT	@docs;
				PRINT	@stars;
		END
END
